//package DatabaseCommands;
//
//import java.sql.Connection;
//import java.sql.DatabaseMetaData;
//import java.sql.ResultSet;
//import java.sql.Statement;
//
//
//public class TestsDatabaseConnection
//{
//    public void testCreateConnection() throws Exception
//    {
//        DatabaseManager dm = DatabaseManager.getInstance();
//        dm.activateJDBC();
//        DatabaseInfo di = new DatabaseInfo(SWQuery.DB_LOCATION, SWQuery.LOGIN_NAME, SWQuery.PASSWORD);
//        Connection dbConnection = di.makeConnection();
//        
//        String[] tables = { "JOBS", "JOBS_SSN", "NUMBERS", "USERS", "BOB" };
//        String[] types = { "TABLE" };
//        DatabaseMetaData meta = dbConnection.getMetaData();
//        for (int x=0;x<tables.length;x++)
//        {
//            ResultSet rs = meta.getTables(null, null, tables[x], types);
//            if (rs.next())
//            {
//                String selectData = new String("SELECT * FROM "+tables[x]);
//                Statement stmt = dbConnection.createStatement();
//                ResultSet rs2 = stmt.executeQuery(selectData);
//                while (rs2.next())
//                {
//                    System.out.println(tables[x] + " has a value "+rs2.getString(1));
//                }
//            }
//        }
//    }
//
//}
